Table: Employee Timecard Detail

Table: UPUTCD
View: UP0103
Record length: 85
Flags: A R 

Keys: 2

Title  Flags  Fields

Timecard Date   EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE
Timecard Earning   EMPLOYEE, ENDDATE, EARNDED, UNIQUE, PAYDATE

Fields: 17

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
ENDDATE  Date  End Date   
PAYDATE  Date  Pay Date   
EARNDED  String*6  Earning/Expense/Tip Code  Mask: %-6N
UNIQUE  Integer  Unique Key Field   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CATEGORY  Integer  Category  List: 3 entries
0=Hours
1=Tips
2=Expense
STARTTIME  Integer  Start Time   
STOPTIME  Integer  Stop Time   
HOURS  BCD*4.3  Hours Worked   
TIPSEXP  BCD*9.5  Tips/Expense Amount   
SHIFTSCHED  String*6  Shift Differential Schedule  Mask: %-6N
SHIFTNUM  Integer  Shift Number   
VALUES  Long  Number of Optional Fields   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.